﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

/// <summary>
///KHYQXZ 的摘要说明
/// </summary>
public class KHYQXZ
{
  public KHYQXZ()
  {
    //
    //TODO: 在此处添加构造函数逻辑
    //
  }
  public static DataSet GetDS(string khid, string cbsjid)
  {
    string sSql = @"select * from v_kh_yqxz a left join 
(select * from SJLR_BQQL b where b.CBSJID=@1) b on a.YQXZID=b.YQXZID where khid=@0
";
    SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@0", SqlDbType.VarChar, 20),
      new SqlParameter("@1", SqlDbType.VarChar, 20) };
    cmdParams[0].Value = khid;
    cmdParams[1].Value = cbsjid;
    DataSet ds = DbHelperSQL.Query(sSql, cmdParams);
    return ds;
  }
}